TenderDepositReceiptTransaction

Entity Definition

Logical Name : TenderDepositReceiptTransaction
Physical Name : TR_DS_TND

A type of TenderControlTransaction that records the movement of tender between a Safe and an ExternalDepository (bank). This entity captures the movement of tender from an external depository into a safet (RECEIPT) and the movement of tender from a safe to an external depository (DEPOSIT).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
OutboundTenderRepository (FK) The unique identifier for the TENDER RESPOSITORY. ID_OTB_TND_RPSTY Identity integer Safe(AS_SF)
InboundTenderRepositoryID (FK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND_TO Identity integer ExternalDepository(LO_EXTDST)
Depositing (FK) A unique system-assigned identifier for the Person who made this TenderDeposit. ID_WRKR_DS Identity integer Worker(PA_WRKR)
DepositBagID A unique identifier for the Deposit Bag that was used to transport the Tender from the Safe to the ExternalDepository. ID_BG_DS Identity integer
Description A shor narrative description of the DepositTransaction. DE_DS DescriptionShort varchar(255)
Amount The total monetary value (in the default system currency) of all TenderLineItems in this DepositTransaction. MO_DS MoneyShortRetail decimal(7,2)
ForeignCurrencyAmount The total monetary value (in the currency being deposited) of all TenderLineItems in this DepositTransaction. MO_DS_FRG_CY MoneyShortRetail decimal(7,2)
OverAmount The total monetary value (in the default system currency) that was over the recorded amount when the deposit bag was checked at the ExternalDepository. MO_OVR MoneyShortRetail decimal(7,2)
OverForeignCurrencyAmount The total monetary value (in the currency being deposited) that was over the recorded amount when the deposit bag was checked at the ExternalDepository. MO_OVR_FRG_CY MoneyShortRetail decimal(7,2)
ShortAmount The total monetary value (in the default system currency) that was under the recorded amount when the deposit bag was checked at the ExternalDepository. MO_SHRT MoneyShortRetail decimal(7,2)
ShortForeignCurrencyAmount The total monetary value (in the currency being deposited) that was under the recorded amount when the deposit bag was checked at the ExternalDepository. MO_SHRT_FRG_CY MoneyShortRetail decimal(7,2)
SafeTenderMovementCode A code that indicates the movement of tender with respect to a SAFE. It is used to clarify whether tender is being RECEIVED into a store safe from an external repository or DEPOSITED from a safe into an external depository. Valid values: RECEIPT - inbound from external dep. to safe DEPOSIT - outbound from safe to ext dep. CD_SF_TND__MV Code varchar(20)

Relationships

Parent Entity Verb Phrase Child Entity
Worker is depositor TenderDepositReceiptTransaction
Safe dispenses tender via TenderDepositReceiptTransaction
ExternalDepository receives tender via TenderDepositReceiptTransaction
TenderControlTransaction can be a TenderDepositReceiptTransaction

Logical Views containing TenderDepositReceiptTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 03160 - Reporting - Store Operations - Till View
Logical 04000 - Financial Ledger - Macro View
Logical 04200 - Financial Ledger - Tender Ctrl Transaction View